ALTER PROCEDURE [dbo].[sp_selete_question_figure]     @QUESTION_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION_FIGURE]    WHERE [QUESTION_ID] = @QUESTION_IDENDALTER PROCEDURE [dbo].[sp_select_question_info]     @QUESTION_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION_INFO]    WHERE [QUESTION_ID] = @QUESTION_IDENDALTER PROCEDURE [dbo].[sp_question_item_select]     @QUESTION_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION_ITEM]     WHERE [QUESTION_ID] = @QUESTION_IDENDALTER PROCEDURE [dbo].[sp_question_item_figure_select]     @ITEM_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION_ITEM_FIGURE]     WHERE [ITEM_ID] = @ITEM_IDENDALTER PROCEDURE [dbo].[sp_question_solution_select]     @ITEM_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION_SOLUTION]     WHERE [ITEM_ID] = @ITEM_IDENDCREATE PROCEDURE [dbo].[sp_selete_figure_link]
     @FIGURE_ID numeric
    
AS
BEGIN

    DELETE FROM [dbo].[FIGURELINK]
    WHERE [FIGURE_ID] = @FIGURE_ID

END

ALTER PROCEDURE [dbo].[sp_selete_question_figure]
     @QUESTION_ID numeric
    
AS
BEGIN

    SELECT * FROM [dbo].[QUESTION_FIGURE]
    WHERE [QUESTION_ID] = @QUESTION_ID

END

ALTER PROCEDURE [dbo].[sp_question_select]     @QUESTION_ID numeric    ASBEGIN    SELECT * FROM [dbo].[QUESTION]     WHERE [QUESTION_ID] = @QUESTION_IDEND
